USE [wdms]
GO


-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetUserDepartment (
	@par_userid int
	)
AS
BEGIN
	SELECT [User1_Dept].[dept_id]
	FROM  [User1_Dept]
	WHERE @par_userid=[User1_Dept].[user1_id]
	/* SET NOCOUNT ON */
END
